<?php
#BigDB采集/自动更新系统
$strBigDBListTableCreateSQL="
CREATE TABLE IF NOT EXISTS`xp121_thread_list` (
  `Id` int(11) NOT NULL auto_increment,
  `typename` varchar(10) default NULL,
  `title` varchar(100) default NULL,
  `link` varchar(255) default NULL,
  `pubtime` varchar(20) default NULL,
  `author` varchar(30) default NULL,
  `lastauthor` varchar(30) default NULL,
  `views` varchar(10) default NULL,
  `lasttime` varchar(20) default NULL,
  `posts` varchar(10) default NULL,
  `pForum` varchar(30) default NULL,
  `sForum` varchar(30) default NULL,
  `FromForumThreadId` int(11) default NULL,
  `newcate` varchar(10) default NULL,
  `haspub` int(11) unsigned default '0',
  PRIMARY KEY  (`Id`),
  UNIQUE KEY `link` (`link`),
  KEY `FromForumThreadId` (`FromForumThreadId`),
  KEY `typename` (`typename`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;";

$strBigDBContentTableCreateSQL="
CREATE TABLE `xp121_thread_content` (
  `Id` int(11) NOT NULL auto_increment,
  `tType` varchar(20) default NULL,
  `localThreadId` int(11) default NULL,
  `FromForumThreadId` int(11) default NULL,
  `content` text,
  `haspub` bigint(20) unsigned default '0',
  PRIMARY KEY  (`Id`),
  KEY `localThreadId` (`localThreadId`),
  KEY `FromForumThreadId` (`FromForumThreadId`)
) ENGINE=MyISAM AUTO_INCREMENT=237069 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;";
?>